﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataBill" targetNamespace="http://tempuri.org/DataBill.xsd" xmlns:mstns="http://tempuri.org/DataBill.xsd" xmlns="http://tempuri.org/DataBill.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CoffeManagementConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CoffeManagementConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Thefaceless.Properties.Settings.GlobalReference.Default.CoffeManagementConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CHITIETHOADONTableAdapter" GeneratorDataComponentClassName="CHITIETHOADONTableAdapter" Name="CHITIETHOADON" UserDataComponentName="CHITIETHOADONTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoffeManagementConnectionString (Settings)" DbObjectName="CoffeManagement.dbo.CHITIETHOADON" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CHITIETHOADON] WHERE (([MaHD] = @Original_MaHD) AND ([MaDoUong] = @Original_MaDoUong) AND ((@IsNull_SoLuong = 1 AND [SoLuong] IS NULL) OR ([SoLuong] = @Original_SoLuong)) AND ((@IsNull_GiaTien = 1 AND [GiaTien] IS NULL) OR ([GiaTien] = @Original_GiaTien)) AND ((@IsNull_Tong = 1 AND [Tong] IS NULL) OR ([Tong] = @Original_Tong)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaHD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaDoUong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaTien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_GiaTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Tong" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Tong" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CHITIETHOADON] ([MaHD], [MaDoUong], [SoLuong], [GiaTien], [Tong]) VALUES (@MaHD, @MaDoUong, @SoLuong, @GiaTien, @Tong);
SELECT MaHD, MaDoUong, SoLuong, GiaTien, Tong FROM CHITIETHOADON WHERE (MaDoUong = @MaDoUong) AND (MaHD = @MaHD)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaHD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaDoUong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@GiaTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Tong" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Tong" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MaHD, MaDoUong, SoLuong, GiaTien, Tong FROM dbo.CHITIETHOADON where MaHD = @hd</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="hd" ColumnName="MaHD" DataSourceName="CoffeManagement.dbo.CHITIETHOADON" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@hd" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CHITIETHOADON] SET [MaHD] = @MaHD, [MaDoUong] = @MaDoUong, [SoLuong] = @SoLuong, [GiaTien] = @GiaTien, [Tong] = @Tong WHERE (([MaHD] = @Original_MaHD) AND ([MaDoUong] = @Original_MaDoUong) AND ((@IsNull_SoLuong = 1 AND [SoLuong] IS NULL) OR ([SoLuong] = @Original_SoLuong)) AND ((@IsNull_GiaTien = 1 AND [GiaTien] IS NULL) OR ([GiaTien] = @Original_GiaTien)) AND ((@IsNull_Tong = 1 AND [Tong] IS NULL) OR ([Tong] = @Original_Tong)));
SELECT MaHD, MaDoUong, SoLuong, GiaTien, Tong FROM CHITIETHOADON WHERE (MaDoUong = @MaDoUong) AND (MaHD = @MaHD)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaHD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaDoUong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@GiaTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Tong" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Tong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaHD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaDoUong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaTien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_GiaTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Tong" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Tong" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaHD" DataSetColumn="MaHD" />
              <Mapping SourceColumn="MaDoUong" DataSetColumn="MaDoUong" />
              <Mapping SourceColumn="SoLuong" DataSetColumn="SoLuong" />
              <Mapping SourceColumn="GiaTien" DataSetColumn="GiaTien" />
              <Mapping SourceColumn="Tong" DataSetColumn="Tong" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HOADONTableAdapter" GeneratorDataComponentClassName="HOADONTableAdapter" Name="HOADON" UserDataComponentName="HOADONTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoffeManagementConnectionString (Settings)" DbObjectName="CoffeManagement.dbo.HOADON" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[HOADON] WHERE (([MaHD] = @Original_MaHD) AND ((@IsNull_MaNV = 1 AND [MaNV] IS NULL) OR ([MaNV] = @Original_MaNV)) AND ((@IsNull_NgayHD = 1 AND [NgayHD] IS NULL) OR ([NgayHD] = @Original_NgayHD)) AND ((@IsNull_ThanhTien = 1 AND [ThanhTien] IS NULL) OR ([ThanhTien] = @Original_ThanhTien)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaHD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MaNV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaNV" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaNV" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaNV" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayHD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayHD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayHD" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayHD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThanhTien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThanhTien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ThanhTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ThanhTien" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[HOADON] ([MaHD], [MaNV], [NgayHD], [ThanhTien]) VALUES (@MaHD, @MaNV, @NgayHD, @ThanhTien);
SELECT MaHD, MaNV, NgayHD, ThanhTien FROM HOADON WHERE (MaHD = @MaHD)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaHD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaNV" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaNV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayHD" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayHD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ThanhTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ThanhTien" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MaHD, MaNV, NgayHD, ThanhTien FROM dbo.HOADON where MaHD = @hd</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="hd" ColumnName="MaHD" DataSourceName="CoffeManagement.dbo.HOADON" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@hd" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[HOADON] SET [MaHD] = @MaHD, [MaNV] = @MaNV, [NgayHD] = @NgayHD, [ThanhTien] = @ThanhTien WHERE (([MaHD] = @Original_MaHD) AND ((@IsNull_MaNV = 1 AND [MaNV] IS NULL) OR ([MaNV] = @Original_MaNV)) AND ((@IsNull_NgayHD = 1 AND [NgayHD] IS NULL) OR ([NgayHD] = @Original_NgayHD)) AND ((@IsNull_ThanhTien = 1 AND [ThanhTien] IS NULL) OR ([ThanhTien] = @Original_ThanhTien)));
SELECT MaHD, MaNV, NgayHD, ThanhTien FROM HOADON WHERE (MaHD = @MaHD)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaHD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaNV" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaNV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@NgayHD" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayHD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ThanhTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ThanhTien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaHD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaHD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MaNV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaNV" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaNV" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaNV" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayHD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayHD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_NgayHD" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="NgayHD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThanhTien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThanhTien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ThanhTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ThanhTien" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaHD" DataSetColumn="MaHD" />
              <Mapping SourceColumn="MaNV" DataSetColumn="MaNV" />
              <Mapping SourceColumn="NgayHD" DataSetColumn="NgayHD" />
              <Mapping SourceColumn="ThanhTien" DataSetColumn="ThanhTien" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DANHMUCDOUONGTableAdapter" GeneratorDataComponentClassName="DANHMUCDOUONGTableAdapter" Name="DANHMUCDOUONG" UserDataComponentName="DANHMUCDOUONGTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CoffeManagementConnectionString (Settings)" DbObjectName="CoffeManagement.dbo.DANHMUCDOUONG" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DANHMUCDOUONG] WHERE (([MaDoUong] = @Original_MaDoUong) AND ((@IsNull_TenDoUong = 1 AND [TenDoUong] IS NULL) OR ([TenDoUong] = @Original_TenDoUong)) AND ((@IsNull_GiaTien = 1 AND [GiaTien] IS NULL) OR ([GiaTien] = @Original_GiaTien)) AND ((@IsNull_SoLuong = 1 AND [SoLuong] IS NULL) OR ([SoLuong] = @Original_SoLuong)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaDoUong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenDoUong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenDoUong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TenDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TenDoUong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaTien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_GiaTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DANHMUCDOUONG] ([MaDoUong], [TenDoUong], [GiaTien], [SoLuong]) VALUES (@MaDoUong, @TenDoUong, @GiaTien, @SoLuong);
SELECT MaDoUong, TenDoUong, GiaTien, SoLuong FROM DANHMUCDOUONG WHERE (MaDoUong = @MaDoUong)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaDoUong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TenDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TenDoUong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@GiaTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MaDoUong, TenDoUong, GiaTien, SoLuong FROM dbo.DANHMUCDOUONG</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DANHMUCDOUONG] SET [MaDoUong] = @MaDoUong, [TenDoUong] = @TenDoUong, [GiaTien] = @GiaTien, [SoLuong] = @SoLuong WHERE (([MaDoUong] = @Original_MaDoUong) AND ((@IsNull_TenDoUong = 1 AND [TenDoUong] IS NULL) OR ([TenDoUong] = @Original_TenDoUong)) AND ((@IsNull_GiaTien = 1 AND [GiaTien] IS NULL) OR ([GiaTien] = @Original_GiaTien)) AND ((@IsNull_SoLuong = 1 AND [SoLuong] IS NULL) OR ([SoLuong] = @Original_SoLuong)));
SELECT MaDoUong, TenDoUong, GiaTien, SoLuong FROM DANHMUCDOUONG WHERE (MaDoUong = @MaDoUong)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MaDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaDoUong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TenDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TenDoUong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@GiaTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MaDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MaDoUong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenDoUong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenDoUong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TenDoUong" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TenDoUong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaTien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_GiaTien" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GiaTien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SoLuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoLuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaDoUong" DataSetColumn="MaDoUong" />
              <Mapping SourceColumn="TenDoUong" DataSetColumn="TenDoUong" />
              <Mapping SourceColumn="GiaTien" DataSetColumn="GiaTien" />
              <Mapping SourceColumn="SoLuong" DataSetColumn="SoLuong" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataBill" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataBill" msprop:Generator_UserDSName="DataBill">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="CHITIETHOADON" msprop:Generator_TableClassName="CHITIETHOADONDataTable" msprop:Generator_TableVarName="tableCHITIETHOADON" msprop:Generator_TablePropName="CHITIETHOADON" msprop:Generator_RowDeletingName="CHITIETHOADONRowDeleting" msprop:Generator_RowChangingName="CHITIETHOADONRowChanging" msprop:Generator_RowEvHandlerName="CHITIETHOADONRowChangeEventHandler" msprop:Generator_RowDeletedName="CHITIETHOADONRowDeleted" msprop:Generator_UserTableName="CHITIETHOADON" msprop:Generator_RowChangedName="CHITIETHOADONRowChanged" msprop:Generator_RowEvArgName="CHITIETHOADONRowChangeEvent" msprop:Generator_RowClassName="CHITIETHOADONRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaHD" msprop:Generator_ColumnVarNameInTable="columnMaHD" msprop:Generator_ColumnPropNameInRow="MaHD" msprop:Generator_ColumnPropNameInTable="MaHDColumn" msprop:Generator_UserColumnName="MaHD">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaDoUong" msprop:Generator_ColumnVarNameInTable="columnMaDoUong" msprop:Generator_ColumnPropNameInRow="MaDoUong" msprop:Generator_ColumnPropNameInTable="MaDoUongColumn" msprop:Generator_UserColumnName="MaDoUong">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SoLuong" msprop:Generator_ColumnVarNameInTable="columnSoLuong" msprop:Generator_ColumnPropNameInRow="SoLuong" msprop:Generator_ColumnPropNameInTable="SoLuongColumn" msprop:Generator_UserColumnName="SoLuong" type="xs:int" minOccurs="0" />
              <xs:element name="GiaTien" msprop:Generator_ColumnVarNameInTable="columnGiaTien" msprop:Generator_ColumnPropNameInRow="GiaTien" msprop:Generator_ColumnPropNameInTable="GiaTienColumn" msprop:Generator_UserColumnName="GiaTien" type="xs:double" minOccurs="0" />
              <xs:element name="Tong" msprop:Generator_ColumnVarNameInTable="columnTong" msprop:Generator_ColumnPropNameInRow="Tong" msprop:Generator_ColumnPropNameInTable="TongColumn" msprop:Generator_UserColumnName="Tong" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="HOADON" msprop:Generator_TableClassName="HOADONDataTable" msprop:Generator_TableVarName="tableHOADON" msprop:Generator_TablePropName="HOADON" msprop:Generator_RowDeletingName="HOADONRowDeleting" msprop:Generator_RowChangingName="HOADONRowChanging" msprop:Generator_RowEvHandlerName="HOADONRowChangeEventHandler" msprop:Generator_RowDeletedName="HOADONRowDeleted" msprop:Generator_UserTableName="HOADON" msprop:Generator_RowChangedName="HOADONRowChanged" msprop:Generator_RowEvArgName="HOADONRowChangeEvent" msprop:Generator_RowClassName="HOADONRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaHD" msprop:Generator_ColumnVarNameInTable="columnMaHD" msprop:Generator_ColumnPropNameInRow="MaHD" msprop:Generator_ColumnPropNameInTable="MaHDColumn" msprop:Generator_UserColumnName="MaHD">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaNV" msprop:Generator_ColumnVarNameInTable="columnMaNV" msprop:Generator_ColumnPropNameInRow="MaNV" msprop:Generator_ColumnPropNameInTable="MaNVColumn" msprop:Generator_UserColumnName="MaNV" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NgayHD" msprop:Generator_ColumnVarNameInTable="columnNgayHD" msprop:Generator_ColumnPropNameInRow="NgayHD" msprop:Generator_ColumnPropNameInTable="NgayHDColumn" msprop:Generator_UserColumnName="NgayHD" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ThanhTien" msprop:Generator_ColumnVarNameInTable="columnThanhTien" msprop:Generator_ColumnPropNameInRow="ThanhTien" msprop:Generator_ColumnPropNameInTable="ThanhTienColumn" msprop:Generator_UserColumnName="ThanhTien" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DANHMUCDOUONG" msprop:Generator_TableClassName="DANHMUCDOUONGDataTable" msprop:Generator_TableVarName="tableDANHMUCDOUONG" msprop:Generator_TablePropName="DANHMUCDOUONG" msprop:Generator_RowDeletingName="DANHMUCDOUONGRowDeleting" msprop:Generator_RowChangingName="DANHMUCDOUONGRowChanging" msprop:Generator_RowEvHandlerName="DANHMUCDOUONGRowChangeEventHandler" msprop:Generator_RowDeletedName="DANHMUCDOUONGRowDeleted" msprop:Generator_UserTableName="DANHMUCDOUONG" msprop:Generator_RowChangedName="DANHMUCDOUONGRowChanged" msprop:Generator_RowEvArgName="DANHMUCDOUONGRowChangeEvent" msprop:Generator_RowClassName="DANHMUCDOUONGRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaDoUong" msprop:Generator_ColumnVarNameInTable="columnMaDoUong" msprop:Generator_ColumnPropNameInRow="MaDoUong" msprop:Generator_ColumnPropNameInTable="MaDoUongColumn" msprop:Generator_UserColumnName="MaDoUong">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenDoUong" msprop:Generator_ColumnVarNameInTable="columnTenDoUong" msprop:Generator_ColumnPropNameInRow="TenDoUong" msprop:Generator_ColumnPropNameInTable="TenDoUongColumn" msprop:Generator_UserColumnName="TenDoUong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GiaTien" msprop:Generator_ColumnVarNameInTable="columnGiaTien" msprop:Generator_ColumnPropNameInRow="GiaTien" msprop:Generator_ColumnPropNameInTable="GiaTienColumn" msprop:Generator_UserColumnName="GiaTien" type="xs:double" minOccurs="0" />
              <xs:element name="SoLuong" msprop:Generator_ColumnVarNameInTable="columnSoLuong" msprop:Generator_ColumnPropNameInRow="SoLuong" msprop:Generator_ColumnPropNameInTable="SoLuongColumn" msprop:Generator_UserColumnName="SoLuong" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CHITIETHOADON" />
      <xs:field xpath="mstns:MaHD" />
      <xs:field xpath="mstns:MaDoUong" />
    </xs:unique>
    <xs:unique name="HOADON_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:HOADON" />
      <xs:field xpath="mstns:MaHD" />
    </xs:unique>
    <xs:unique name="DANHMUCDOUONG_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DANHMUCDOUONG" />
      <xs:field xpath="mstns:MaDoUong" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK__CHITIETHOA__MaHD__1CF15040" msdata:parent="HOADON" msdata:child="CHITIETHOADON" msdata:parentkey="MaHD" msdata:childkey="MaHD" msprop:Generator_UserChildTable="CHITIETHOADON" msprop:Generator_ChildPropName="GetCHITIETHOADONRows" msprop:Generator_UserRelationName="FK__CHITIETHOA__MaHD__1CF15040" msprop:Generator_RelationVarName="relationFK__CHITIETHOA__MaHD__1CF15040" msprop:Generator_UserParentTable="HOADON" msprop:Generator_ParentPropName="HOADONRow" />
      <msdata:Relationship name="FK__CHITIETHO__MaDoU__1DE57479" msdata:parent="DANHMUCDOUONG" msdata:child="CHITIETHOADON" msdata:parentkey="MaDoUong" msdata:childkey="MaDoUong" msprop:Generator_UserChildTable="CHITIETHOADON" msprop:Generator_ChildPropName="GetCHITIETHOADONRows" msprop:Generator_UserRelationName="FK__CHITIETHO__MaDoU__1DE57479" msprop:Generator_RelationVarName="relationFK__CHITIETHO__MaDoU__1DE57479" msprop:Generator_UserParentTable="DANHMUCDOUONG" msprop:Generator_ParentPropName="DANHMUCDOUONGRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>